﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="AssessorDetails" targetNamespace="http://tempuri.org/AssessorDetails.xsd" xmlns:mstns="http://tempuri.org/AssessorDetails.xsd" xmlns="http://tempuri.org/AssessorDetails.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="ConnLeadCreation" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnLeadCreation (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.ConnLeadCreation.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Usp_GetAssessorDetailsTableAdapter" GeneratorDataComponentClassName="Usp_GetAssessorDetailsTableAdapter" Name="Usp_GetAssessorDetails" UserDataComponentName="Usp_GetAssessorDetailsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnLeadCreation (Web.config)" DbObjectName="IQKSUAT.dbo.Usp_GetAssessorDetails" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Usp_GetAssessorDetails</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@InvoiceID" Precision="19" ProviderType="BigInt" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="BILLTO" DataSetColumn="BILLTO" />
              <Mapping SourceColumn="FORTO" DataSetColumn="FORTO" />
              <Mapping SourceColumn="BankName" DataSetColumn="BankName" />
              <Mapping SourceColumn="SWIFTCode" DataSetColumn="SWIFTCode" />
              <Mapping SourceColumn="BankCode" DataSetColumn="BankCode" />
              <Mapping SourceColumn="AccountNo" DataSetColumn="AccountNo" />
              <Mapping SourceColumn="InvoiceID" DataSetColumn="InvoiceID" />
              <Mapping SourceColumn="InvoiceNo" DataSetColumn="InvoiceNo" />
              <Mapping SourceColumn="InvoiceAmount" DataSetColumn="InvoiceAmount" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="AssAddress" DataSetColumn="AssAddress" />
              <Mapping SourceColumn="PhoneNo" DataSetColumn="PhoneNo" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="AssessorDetails" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="False" msprop:Generator_DataSetName="AssessorDetails" msprop:Generator_UserDSName="AssessorDetails">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Usp_GetAssessorDetails" msprop:Generator_TableClassName="Usp_GetAssessorDetailsDataTable" msprop:Generator_TableVarName="tableUsp_GetAssessorDetails" msprop:Generator_RowChangedName="Usp_GetAssessorDetailsRowChanged" msprop:Generator_TablePropName="Usp_GetAssessorDetails" msprop:Generator_RowDeletingName="Usp_GetAssessorDetailsRowDeleting" msprop:Generator_RowChangingName="Usp_GetAssessorDetailsRowChanging" msprop:Generator_RowEvHandlerName="Usp_GetAssessorDetailsRowChangeEventHandler" msprop:Generator_RowDeletedName="Usp_GetAssessorDetailsRowDeleted" msprop:Generator_RowClassName="Usp_GetAssessorDetailsRow" msprop:Generator_UserTableName="Usp_GetAssessorDetails" msprop:Generator_RowEvArgName="Usp_GetAssessorDetailsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="BILLTO" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnBILLTO" msprop:Generator_ColumnPropNameInRow="BILLTO" msprop:Generator_ColumnPropNameInTable="BILLTOColumn" msprop:Generator_UserColumnName="BILLTO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="93" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FORTO" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnFORTO" msprop:Generator_ColumnPropNameInRow="FORTO" msprop:Generator_ColumnPropNameInTable="FORTOColumn" msprop:Generator_UserColumnName="FORTO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="52" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BankName" msprop:Generator_ColumnVarNameInTable="columnBankName" msprop:Generator_ColumnPropNameInRow="BankName" msprop:Generator_ColumnPropNameInTable="BankNameColumn" msprop:Generator_UserColumnName="BankName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SWIFTCode" msprop:Generator_ColumnVarNameInTable="columnSWIFTCode" msprop:Generator_ColumnPropNameInRow="SWIFTCode" msprop:Generator_ColumnPropNameInTable="SWIFTCodeColumn" msprop:Generator_UserColumnName="SWIFTCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BankCode" msprop:Generator_ColumnVarNameInTable="columnBankCode" msprop:Generator_ColumnPropNameInRow="BankCode" msprop:Generator_ColumnPropNameInTable="BankCodeColumn" msprop:Generator_UserColumnName="BankCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccountNo" msprop:Generator_ColumnVarNameInTable="columnAccountNo" msprop:Generator_ColumnPropNameInRow="AccountNo" msprop:Generator_ColumnPropNameInTable="AccountNoColumn" msprop:Generator_UserColumnName="AccountNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InvoiceID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnInvoiceID" msprop:Generator_ColumnPropNameInRow="InvoiceID" msprop:Generator_ColumnPropNameInTable="InvoiceIDColumn" msprop:Generator_UserColumnName="InvoiceID" type="xs:long" />
              <xs:element name="InvoiceNo" msprop:Generator_ColumnVarNameInTable="columnInvoiceNo" msprop:Generator_ColumnPropNameInRow="InvoiceNo" msprop:Generator_ColumnPropNameInTable="InvoiceNoColumn" msprop:Generator_UserColumnName="InvoiceNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InvoiceAmount" msprop:Generator_ColumnVarNameInTable="columnInvoiceAmount" msprop:Generator_ColumnPropNameInRow="InvoiceAmount" msprop:Generator_ColumnPropNameInTable="InvoiceAmountColumn" msprop:Generator_UserColumnName="InvoiceAmount" type="xs:decimal" minOccurs="0" />
              <xs:element name="Name" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="101" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AssAddress" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnAssAddress" msprop:Generator_ColumnPropNameInRow="AssAddress" msprop:Generator_ColumnPropNameInTable="AssAddressColumn" msprop:Generator_UserColumnName="AssAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="617" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PhoneNo" msprop:Generator_ColumnVarNameInTable="columnPhoneNo" msprop:Generator_ColumnPropNameInRow="PhoneNo" msprop:Generator_ColumnPropNameInTable="PhoneNoColumn" msprop:Generator_UserColumnName="PhoneNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InvoiceDate" msprop:Generator_ColumnVarNameInTable="columnInvoiceDate" msprop:Generator_ColumnPropNameInRow="InvoiceDate" msprop:Generator_ColumnPropNameInTable="InvoiceDateColumn" msprop:Generator_UserColumnName="InvoiceDate" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Usp_GetAssessorDetails" />
      <xs:field xpath="mstns:InvoiceID" />
    </xs:unique>
  </xs:element>
</xs:schema>